package com.bdsy.business.dao;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Param;

import com.bdsy.business.model.ShopSellInfo;

public interface ShopSellInfoMapper {

	List<Map> selectShopSellInfo();
	
	List<Map> selectzlShopSellInfo();
	
	List<Map> shopSellInfoListByTypeId(Integer shopTypeId);
	
	List<Map> shopzlSellInfoListByTypeId(Integer shopTypeId);
	
	int count(Integer shopTypeId);
	
	int zcount(Integer shopTypeId);
	
	List<ShopSellInfo> selectShopInfo();
	
	List<Map> selectShopSellInfoById(String userId);
	
	List<Map> selectzlShopSellInfoById(String userId);
	
	List<Map> selectShopSellInfoByShopId(Integer shopId);
	
	List<Map> selectShopSellInfoByIcdn(String icdn);
	
	List<Map> shopSellInfoByIcdn(String icdn);
	  
    int insert(ShopSellInfo shopSellInfo);
    
    int delete(@Param(value = "pIds")List<String> pIds);
    
    //在售物品数量统计 
    int sellCount(String userId);
    
    //在售物品数量统计 
    int zlCount(String userId);
    
    // ht 根据 用户id 出售/租赁状态 上下架 查询商品信息
    List<Map> selectShopSellInfoByIdStatus(@Param(value = "userId")String userId,@Param(value = "sStatus")int sStatus,@Param(value = "standDown")int standDown);

    List<Map> selectShopSellInfoByuserIdStatus(@Param(value = "userId")String userId,@Param(value = "sStatus")int status);

    //修改商品信息
    int update(ShopSellInfo shopSellInfo);
    
    // 商品上下架
    int updateShopStatus(ShopSellInfo shopSellInfo);
    
    //根据用户查询下架信息
    List<Map> selectShopSellInfoByIdStand(@Param(value = "userId")String userId,@Param(value = "sStatus")Integer sStatus);
    
    //细节图 根据商品id 查询图片信息
    List<Map> imageInfoById(int shopId);
    
    //根据年代 起始时间查询信息
    List<Map> shopListByTime(@Param(value = "fromDate")String fromDate,@Param(value = "toDate")String toDate,@Param(value = "userId")String userId,@Param(value = "sStatus")int sStatus);

    //查询所有艺术品信息
    List<Map> selectAllShopSellInfo();

    //修改鉴定状态
    int updateIdentStatus(@Param(value = "identStatus")Integer identStatus,@Param(value = "shopId")Integer shopId);
}
